English 中文(简体)
Is it possible to concatenate a column which contains values as number and text with another column in Power Query?
原标题:

I m trying to concatenate a column containing SKUs that don t follow a pattern (some fields with numbers only while others with both text and number) and another column which contains only text. Does anyone know if it is possible to do that in Power Query? Since there is fields with different formats in the first column (e.g. OCI-110; 1354; etc.), none of the methods worked for me.

I ve tried the conventional methods to make the concatenation. Perhaps a conditional concatenation could work, however I have no idea about|a M synthax for this.

Thanks!

问题回答

暂无回答




相关问题
Concatenating strings in macros - C++

What s the easiest way to concatenate strings defined in macros. i.e. The pseudo code I m looking for would be like: #define ROOT_PATH "/home/david/" #define INPUT_FILE_A ROOT_PATH+"data/inputA.bin" #...

How can I concatenate set of results in MySQL?

I would like to join results returned in the set in MySQL with a comma as a separator string. For example, set returned contains: COLUMN_X john jerry maria joseph gugla I would like to receive the ...

热门标签