Product Hiearchy get up level's name

[QSense]

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.

[kaushiknsolanki · Accepted solution]

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

[Shubham_Deshmukh]

Use peek() in your script,

LOAD

myDate, 

mySale,

if(condition,peek(mySale)) as expectedOutput
FROM --------