I have a dataset with around 1000 records. now I want to add one field in it name "id".
it would be starting from 1 and end with 1000.
I don't have an idea how to add it. Please suggest a better way.
Thanks in advance :)
in magic etl
add a constant, 1, called temp
add a rank and window tile.
in a dataset view
rownumber() over ()
To expand on @jaeW_at_Onyx 's answer - The rank and window tile requires a column to order by. That's why you must add a dummy constant / column to your dataset
It looks like you're new here. Those who sign in get access to engage with even MORE fire content. To get involved, click one of these buttons!