Data Reload

[denny_wu]

Hi There,

I need help from you guys.

i have table something like this:

RecipeKey related with SpecKey. so, i want to add new column (column name is "Key). that Key value should be first row of SpecKey.

how to build that script ?

Thanks

Denny Wu

[rubenmarin]

Hi Denny, in script you can do a sorted reload and use Peek() to propagate the value:

https://help.qlik.com/en-US/sense/April2018/Subsystems/Hub/Content/Scripting/InterRecordFunctions/Pe...

If(IsNull(Peek('Key')), Description, Peek('Key')) as Key

Usually you need to group values to 'reset' the propagated value, if not all rows will have the same value.

If(GroupCode<>Peek('GroupCode'), Description, Peek('Key')) as Key

[denny_wu]

What do you mean Group values ?
i dont see can group the values, cause all row is related with column RecipeKey.

[rubenmarin]

Just that usually the value changes on some conditions, like taking the first value of each year, if you want the same value in all rows it doesn't matter. It was only an example.