topic Re: show all Subfield values in table chart visualization in App Development

show all Subfield values in table chart visualization

vimalthehero — Sun, 27 Apr 2025 04:44:57 GMT

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

Re: show all Subfield values in table chart visualization

BrunPierre — Sun, 27 Apr 2025 14:21:56 GMT

Like this.

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

DROP Field Tdays;
RENAME Field TdaysT to Tdays;

Re: show all Subfield values in table chart visualization

vimalthehero — Sun, 27 Apr 2025 14:37:49 GMT

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

Re: show all Subfield values in table chart visualization

krishna20 — Mon, 28 Apr 2025 06:16:02 GMT

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
];

Re: show all Subfield values in table chart visualization

marcus_sommer — Mon, 28 Apr 2025 07:52:53 GMT

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.

Re: show all Subfield values in table chart visualization

Amit_Prajapati — Mon, 28 Apr 2025 09:15:40 GMT

You can also try the below one.

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

TDays

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

Re: show all Subfield values in table chart visualization

sk88024 — Mon, 28 Apr 2025 11:30:46 GMT

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;

Re: show all Subfield values in table chart visualization

Suraj_Y_ — Thu, 01 May 2025 06:08:40 GMT

Thanks for help SubField working