topic Re: Build Column from variables in Load script in App Development

Build Column from variables in Load script

Micki — Fri, 28 Aug 2020 11:25:07 GMT

Hi,

Does somebody know, how to build column in a table from variables

i have $(var1), $(var2), $(var3)

My desired output should be table with column like:

Col1:

var1,

var2

var3

Thanks

Re: Build Column from variables in Load script

sunny_talwar — Fri, 28 Aug 2020 13:02:56 GMT

Does these variables have multiple values or just single value? If they have multiple values, how are you creating these variables in the first place?

Re: Build Column from variables in Load script

PrashantSangle — Fri, 28 Aug 2020 13:10:05 GMT

can you explain little bit more??

Re: Build Column from variables in Load script

Micki — Fri, 28 Aug 2020 13:11:48 GMT

Hi, only single value ( like some names of operations 'Service', 'Main', etc.)

Re: Build Column from variables in Load script

sunny_talwar — Fri, 28 Aug 2020 13:17:42 GMT

Just do this

Col1: LOAD '$(var1)' as var1, '$(var2)' as var2, '$(var3)' as var3 AutoGenerate 1;

Re: Build Column from variables in Load script

Micki — Fri, 28 Aug 2020 13:26:18 GMT

actually it's generate not a column but one row

var1

var2

var3

, but i need it as a column in one table

Col1

var1

var2

var3

Re: Build Column from variables in Load script

Micki — Fri, 28 Aug 2020 13:52:28 GMT

OK, thank you all but i found it at first i generate dummy table with auto generate based on count how many non empty variables , then i used CROSSTABLE to get the result and just uncut the unneeded fileds, quite a funny solution but it works, i will post later code