LOAD script - Data processing creating variables from column values

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

What is the easiest way to get to this without having to write several load steps and IF conditions for each code?

CODE_1_DATE is the date CODE_1 is placed, similarly for other codes

If an Account has two same codes, like 789 below, it has 120 in code_1 and code_2, I would need the 120 that is places latest. so it would be 1/9/2019

In the actual data I have as many as 12-15 codes.

HAVE:

ACCOUNT	CODE_1	CODE_2	CODE_3	code_4	CODE_1_DATE	CODE_2_DATE	CODE_3_DATE	CODE_4_DATE
123	120	121	122		1/2/2019	1/3/2019	1/4/2019
456	120	121	122	123	1/20/2019	1/3/2019	1/5/2019	1/8/2019
789	120	120	122	121	1/8/2019	1/9/2019	1/10/2019	1/15/2019

WANT:

ACCOUNT	CODE_120	CODE_120_DATE	CODE_121	CODE_121_DATE	CODE_122	CODE_122_DATE	CODE_123	CODE_123_DATE
123	Y	1/2/2019	Y	1/3/2019	Y	1/4/2019
456	Y	1/20/2019	Y	1/3/2019	Y	1/5/2019	Y	1/8/2019
789	Y	1/9/2019	Y	1/15/2019	Y	1/10/2019

Re: LOAD script - Data processing creating variables from column values

marcus_sommer — Fri, 01 Feb 2019 08:13:14 GMT

Please do not double posting: LOAD-script-Assign-field-values-to-a-variable

topic LOAD script - Data processing creating variables from column values in QlikView

LOAD script - Data processing creating variables from column values

Re: LOAD script - Data processing creating variables from column values