- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Product Hiearchy get up level's name
Hello ,
I have a case . There is an hiearchy table in my app . I would like write if statement in a straight table.
In my table below, I will add new calculate dimension.
My script like ;
Level | UP | ID | Level_Explanation |
ABC | 2817 | 2839 | ABC explanation |
ABC.1 | 2839 | 2841 | ABC.1 explanation |
ABC.1.1 |
At then end I would like to get this result (red one)
my script would like ; for ABC.1 row
if (one condition satisfies , match(up,level_explanation) ) // I dont know which function is used here.
I would like to get one up level's level explanation.
Level | UP | ID | Level_Explanation | UP Level Explanation |
ABC | 2817 | 2839 | ABC explanation | null |
ABC.1 | 2839 | 2841 | ABC.1 explanation | ABC explanation |
ABC.1.1 |
Thanks in advance.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
A small change in script will get you desired result with no hassle.
Try below script;
Data:
Load Level,UP,ID,Level_Explanation From XYZ;
Left join (Data)
Load ID as UP,Level_Explanation as UP_Level_Explanation From XYZ;
Regards,
Kaushik Solanki
Level | UP | ID | Level_Explanation |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
A small change in script will get you desired result with no hassle.
Try below script;
Data:
Load Level,UP,ID,Level_Explanation From XYZ;
Left join (Data)
Load ID as UP,Level_Explanation as UP_Level_Explanation From XYZ;
Regards,
Kaushik Solanki
Level | UP | ID | Level_Explanation |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Use peek() in your script,
LOAD
myDate,
mySale,
if(condition,peek(mySale)) as expectedOutput
FROM --------