Forum Discussion
arkiboys2
Helper IV
Helper IVdataflow - if there is a row present
hello, in the dataflow gen2, there are several steps from navigation of the source all the way to pivot column. After the pivot, the step is to rename column. But the flow fails on this rename step...
I would add a dummy row with the necessary columns before that step, so that the step doesn't fail, and then I would filter away the dummy row afterwards.
I created a HelperRow which only has columns and no rows.
Then after the pivot step, I appended this helper row.
It seems fine now
thank you
lbendlin
Super User
Super Useruse try ... otherwise ... to decide what to produce in this scenario.
arkiboys2you mean to have try catch inside dataflow gen2? is this the only way?
how is this possible?
thanks
frithjof_vCommunity Champion
You could add a dummy row.
However, do you want the dataflow to succeed if there is no data?
- arkiboys2yes to succeed if there is no row. thanks