Transpose a column and add missing columns

sreekanth2208 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I'm a new bee to Qlikview, Could you please help me with one situation ?

I have a table with two column(Column-1) with multiple values like:

Column-1 Column-2

------------- ------------

X 1

Y 2

Z 3

I have transposed this column and got as below

X Y Z

1 2 3

but yeah, here is my situation,

Where sometimes table consists of only 2 records as

X 1

Y 2

and i want to add the missing records through QV script by checkng whether the field Z is available or not, if not available add a column "Z" and if not available and corresponding value as null and if available do nothing.

Could you please help us on this.

Re: Transpose a column and add missing columns

Brett_Bleess — Tue, 21 Jan 2020 22:13:06 GMT

The only thing of which I can think is to load into a temp resident table then reload and use the Peek() function to check if Z is there or not, maybe the Len() function may work too, not sure:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/InterRecordFunctions/Peek.htm

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/StringFunctions/Len.htm

Likely need some further info and maybe an example data file in order for others to chime in on this one.

You can also have a look around the Design Blog area to see if you can find something there that may help too:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

topic Re: Transpose a column and add missing columns in QlikView

Transpose a column and add missing columns

Re: Transpose a column and add missing columns