append rows to queries with splitted columns

[JUERG_H]

My initial table shows like this:

DATE                     UNSPLITTED_TEXT

20161101              JOHN DOE BRIGHTON

20161101              JODIE SMITH PARIS

20161101              EMILY MCIWAN DUBLIN

I use the split-function of the query-editor and get the split as expected:

DATE                      SPLIT_1                 SPLIT_2              SPLIT_3

20161101              JOHN                     DOE                      BRIGHTON

20161101              JODIE                     SMITH                  PARIS

20161101              EMILY                    MCIWAN              DUBLIN

However when I want to append rows to this table, the split function does not apply to the new rows and the table looks like this:

DATE                     SPLIT_1                SPLIT_2                 SPLIT_3                  UNSPLITTED_TEXT

20161101              JOHN                     DOE                       BRIGHTON              null

20161101              JODIE                     SMITH                   PARIS                       null

20161101              EMILY                     MCIWAN              DUBLIN                    null

20161201              null                         null                         null                         CLAIRE BESSON PARIS    

20161201              null                         null                         null                         MARCO MOLINO ROME

20161201              null                         null                         null                         MARIA SCHMIDT BERLIN  

Is there a way to get the rows splitted automatically when I append them?

[v-yulgu-msft · Accepted solution]

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]

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.