Forum Discussion
Anonymous
3 years agoNot applicable
Replace values in table with values from calculated table based on a condition
Dear all, I'm dealing with store visitation data analysis. The data is very simple - 3 columns: date, store number (8 in total), number of visitors in. There are 2 data sources - Dataflow...
Anonymous
3 years agoNot applicable
Hi Roberts,
thanks for answering, but at step 4 I got stucked - there is just no dialog window, just 2 fields like "Find - Replace with", that's it. Maybe I do something wrong?
And re step 6 - are you sure that it will work with calculated table? It's not even shown in Query Editor mode in the list of tables.
RobertPaegelow
3 years agoHelper I
Hi, i think you have to format the column as text first and then to number again.
- Anonymous3 years agoNot applicable
Unfortunatelly it doesn't make sence, you still have the same interface with no selecting options (