Transpose an Array to another table

[Deny_Pratama]

Hello, I’m back again. I’ve done some digging in the forum, but I couldn’t find the way out yet.

I need to transpose two arrays to another table, where the result I expect will be side-by-side, for my new lookup reference. Here is my table.

The result in the new table that I expect is just like:

Array PUTS | Split_NPK
138 | 15
36 | 10
30 | 12

What is the efficient way to do that?

Additional information:
I’ve tried the method of making RowIndex form RowIDs combined with Single Value, but it’s still not showing what I expected.

[Darren_Murphy]

It’s not working because you’re not targeting the array correctly.
Rather than targeting it via the original table, you should target it directly from the same row.
Your single value column should look something like the below:

[Darren_Murphy]

oh, something else that I just noticed… you are missing a column.
You need a column that applies the array from the other table to every row, and then you need to target that column with the single value column.

How you get the array into the table depends on your specific setup. There are several ways to do it. It could be through a relation and a lookup, or it could be set into a user specific column (either in the helper table or the user profile row) as a navigation action.

[Deny_Pratama]

Back again, Darren, with a good news; after several trial and error.
Thanks for the enlightenment once again.

Here is what I did:

I wonder why I have to Join then Split again to do the transpose with the Single Value.

But I’m okay with that as long as my aim is achieved.

[ThinhDinh]

I’m confused. Why do you need to do the make a join list - split the joined list part?

[Deny_Pratama]

Dear Experts,
Apologize for not replying quickly.

I remembered when last time I transposed directly (not doing join then split), the result was not as I expected. The result showed many values in each row, so I did that trial and error, using join-split then transpose with Single Value.

Until today I tried again change the target column directly to the first column; this time that’s just work
So I just erased those join-split tables, to be like this:

That’s all the columns.

So I created my dynamic reference column for a calculation in another table.

Pardon me for confusing you, but I’m pretty sure the result in previous day showed many values in a row. But today it doesn’t.

[Deny_Pratama]

What is the difference of my first post of thie thread, with this one. Because with same settings, it returned different result then VS now.

I will bring here the picture from my first post.

[ThinhDinh]

@Darren_Murphy

How you get the array into the table depends on your specific setup. There are several ways to do it. It could be through a relation and a lookup, or it could be set into a user specific column (either in the helper table or the user profile row) as a navigation action.

It relates to this part. The ultimate aim is to get the array of values into the helper table.

As long as you can bring that array into every row, then you can set it up the way Darren suggested.