topic Re: How to do this Complex Table & Data Transformation with script! in QlikView

How to do this Complex Table & Data Transformation with script!

imsushantjain — Thu, 16 Aug 2018 07:27:22 GMT

Hi All,

This is the Snapshot of the data I have:

Input:

As per "criteria_name" each Internal Business Unit is linked to each Internal Legal Entity, so here we have 6 Business Unit and 2 Legal Entity which should result in a set of 12 rows (Output).

We can consider "current_exposure" to take the vale from Internal Business Unit row.

Such condition exist for each "exp_line_id", for the sake for example i have only considered one "exp_line_id".

Output:

How can i achieve this output?

This is like reverse CrossTable, but more complex:

Row values as fields (opposite of crosstable?)

Regards

Sushant

Re: How to do this Complex Table & Data Transformation with script!

PrashantSangle — Thu, 16 Aug 2018 08:34:48 GMT

Hi,

try like below

Load risk_expdef_name,

exp_line_id,

facility_name,

short_name as "Internal Business Unit",

current_exposure

From tableName

where criteria_name='Internal Business Unit';

Join

Load risk_expdef_name,

exp_line_id,

facility_name,

short_name as "Internal Legal Entity",

current_exposure

From tableName

where criteria_name='Internal Legal Entity';

Regards,

Re: How to do this Complex Table & Data Transformation with script!

imsushantjain — Thu, 16 Aug 2018 09:25:59 GMT

Hi Prashant,

Thanks for the smart solution, no doubt you are an MVP

Regards

Sushant