Forum Discussion

yokaso's avatar
yokaso
Regular Visitor
1 year ago

split columns with null result

hi, i am trying to split the column "transact" into 02 columns(first picture). but each time i try i got null result on the second column. is there something wrong that i am doing ?     let ...
Need Help
ronrsnfld's avatar
ronrsnfld
Super User
1 year ago

But in your new example, you now have multiple Values for the same Date! In your original post, you only had a single Value for each Date. I'm afraid without examples of your expected output from you pictured input, I will not be able to assist you any further.

 

You keep changing the specifications with each post and I have no idea what you expect for output.

yokaso's avatar
yokaso
Regular Visitor
1 year ago

thank you and sorry for the confusion. you solution is good enough for me .

but if you could explain me what u did the second step ?

 

ronrsnfld wrote:

But in your new example, you now have multiple Values for the same Date! In your original post, you only had a single Value for each Date. I'm afraid without examples of your expected output from you pictured input, I will not be able to assist you any further.

 

You keep changing the specifications with each post and I have no idea what you expect for output.

ronrsnfld wrote:

But in your new example, you now have multiple Values for the same Date! In your original post, you only had a single Value for each Date. I'm afraid without examples of your expected output from you pictured input, I will not be able to assist you any further.

 

You keep changing the specifications with each post and I have no idea what you expect for output.

ronrsnfld wrote:

But in your new example, you now have multiple Values for the same Date! In your original post, you only had a single Value for each Date. I'm afraid without examples of your expected output from you pictured input, I will not be able to assist you any further.

 

You keep changing the specifications with each post and I have no idea what you expect for output.

#"Add Shifted Transactions" = Table.FromColumns(
        {#"Changed Type"[date]}
        & {#"Changed Type"[transaction]}
        & {List.Skip(#"Changed Type"[transaction])}
        & {#"Changed Type"[value]},
        type table[date=date, transaction.1=text, transaction.2=text, value=number]),
  • ronrsnfld's avatar
    ronrsnfld
    Super User
    1 year ago

    That could also be written:

        #"Add Shifted Transactions" = Table.FromColumns(
        Table.ToColumns(#"Changed Type")
        & {List.Skip(#"Changed Type"[transaction])},
        type table[date=date, transaction.1=text, value=number, transaction.2=text]),

    It is creating List for each of the columns in the table, and then adding another column where we Skip the first entry in the transaction column (hence moving it up one).

     

    Examine MS Help for those functions to better understand.

     

    Doing it this way results in the transactions.2 column being the last column, so you need to re-arrange the columns to obtain the desired order.

     

    In the initial code, I controlled the column order by entering each column individually, instead of adding all the original columns and then appending the shifted column.