Forum Discussion
Dataflow - How can I stop automatic steps being added
I'm a total noob, but this is working for me. I was having this same issue, and found this article that explains why it happens is because it is trying to make sure that all columns have an assigned format and not just the defaults. I went into each query and clicked on a value in the results table, did ctrl-A to select all and then did a Detect Data Type. Once I did that it stopped automatically inserting those steps. The only thing is that you can't have a List or a Record as a column because it will still apply those steps since they aren't actual data types. I'm adding those columns as a new query so I can expand the data (this is cleaner then just expanding in the column based on the data) and then I'm removing that column and building a relationship so I can tie the two queries together.