show all Subfield values in table chart visualization

[vimalthehero]

i have a column "TDays" with data "21;15;29;5;6"

when i put function subfield(TDays,';') it get display the first values from the subfield  . 

Can we get all the subfield split data into the table?? as shown belowSubfield

[BrunPierre · Accepted solution]

Like this.

Join
LOAD Student,
SubField(Tdays, ';') AS TdaysT
Resident OriginalTable ;

DROP Field Tdays;
RENAME Field TdaysT to Tdays;

[vimalthehero]

can it be done directly with visualization chart table.. instead of load scripts logic.?

[krishna20]

Hi @vimalthehero ,

You can try this in load editor.

Test:
Load *,
Subfield(Tdays,';') as Days;
Load * Inline [
Name,Tdays
Vimal,2;3;6;21;13
Vijay,3;4;12;22;26
];

[marcus_sommer]

No - at least not with native values and it shouldn't be tried to apply a highly complex logic with a lot of disadvantages in the UI to things which are simply done within the script.

[Amit_Prajapati]

You can also try the below one.

LOAD SubField(TDays, ';', IterNo()) AS Split_TDays,

TDays

FROM YourDataSource
WHILE SubField(TDays, ';', IterNo()) <> '';

Opens in new window

PDF Download

Word Download

Excel Download

PowerPoint Download

Document Download

[sk88024]

This should work - 

Temp:
Load * Inline [
Name,Tdays
Vimal,2;3;6;21;13
Vijay,3;4;12;22;26
];

NoConcatenate
New:
Load Name,
SubField(Tdays, ';', IterNo()) as Tdays
Resident Temp
While IterNo() <= SubStringCount(Tdays, ';') + 1 ;

Drop Table Temp;

[Suraj_Y_]

Thanks for help SubField working