Forum Discussion

JUERG_H's avatar
JUERG_H
Icon for Advocate I rankAdvocate I
9 years ago
Solved

append rows to queries with splitted columns

My initial table shows like this: DATE                     UNSPLITTED_TEXT 20161101              JOHN DOE BRIGHTON 20161101              JODIE SMITH PARIS 20161101              EMILY MCIWAN DUBLI...
Need Help
Tutorial Requests
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi JUERG_H,

     

    Change the order you make actions.  You can append the two tables first and then split the column [UNSPLITTED_TEXT].

     

    Thanks,
    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi JUERG_H,

 

Change the order you make actions.  You can append the two tables first and then split the column [UNSPLITTED_TEXT].

 

Thanks,
Yuliana Gu

JUERG_H's avatar
JUERG_H
Icon for Advocate I rankAdvocate I
9 years ago

Hi Yuliana

Thx for the hint! Great! Never thougtht it could be as easy as that :-)

The order of the steps can be changed by dragging them with the mouse upwards or down.

It is not as automatically as I whished but still effordless enough to be accepted as a solution for my case.