Splitting Line Breaks as separate rows in Spotfire

[Jeisakthiganesh Harihara subramanian]

Hi All,

I am having an input dataset which has line breaks in it. I would like to seperate the line break characters as seperate rows.

Input: (2 rows , 2 columns)

 

 

 

Fruits

Sold to

 

 

Apple

Ricky

John

Alfred

Michael

 

 

Orange

 

Ajay

Ram

 

 

 

 

 

Expected result: (6 rows, 2 columns)

 

 

 

Fruits

Sold to

 

 

Apple

Ricky

 

 

Apple

John

 

 

Apple

Alfred

 

 

Apple

Michael

 

 

Orange

Ajay

 

 

Orange

Ram

 

 

 

 

Please let me know the possibilities of achieving this result set. Thanks!

[Tim Williams 3]

There may be a better way to do it, but I would just prep my data in Excel prior to importing to Spotfire. The way to do it is explained here:https://www.excelarticles.com/excelbook/fill_blanks_with_value_above.html

[Tyger Guzman 2]

What is the datasrouce 

[Jeisakthiganesh Harihara subramanian]

Excel/csv is the source for the dashboard. In the source data i am getting values as mentioned in this post. 

 

Since the source data changes over time, looking for the ways to handle the line breaks within spotfire.

 

It is possible to acheive this result using "splitstackshape" library using R script. But this package need to be installed on spotfire server.

 

please let me know if there is a way to acheive this result using Iron python script

[Jeisakthiganesh Harihara subramanian]

Thanks for your inputs.

 

Since the source data changes over time. I am looking for ways to perform this data preparation within spotfire. Thanks!