Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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,
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,
Hi Prashant,
Thanks for the smart solution, no doubt you are an MVP
Regards
Sushant