Hi everyone,
I want to combine the left side lists to the right side one, shown as the screen capture.
As the screen capture shows, I want to keep the “null” value as the output also if there is no any valid value existed in these lists.
Thanks inadvance.
@Seanc9XFAH does this work
Hi Kai,
Thanks for trying to help.
It looks like working in the example, but unfortunately it will not work in my case.
I got 204 indexes in each list, and the final list should have 204 indexes also. However, base on your scripts I got 374 indexes in a list.
Hi @Vikram_Subbaiah ,
Thanks for trying to help.
Unfortunately, it doesnt work if i got more lists. I think the function I want should base on list comparation first.
For example, the value under index1 in list1 compare to the value under index1 in list2 and the value under index1 in list3. If all of them have a value of “null” under index1 in list1,2 and3, then take the value “null” to the index1 in new list. If the value is “A” under index2 in list1, and the values are “null” under index2 in list2 and list3, then it will take the value “A” to the index2 in the new list. So, under the example above, the new list should have a value “null” under index1 and a value “A” under index2.
Only by doing so, I can keep the same number of index in the new list compare to list1, 2,and 3.
If I use " List.Clean" or “List.UniqueItems” these kind of scrpits, the number of index in the new list will not be the same with list1,2,3 and more.
Thank you very much again.
Thanks for everyone’s help.
In order to make it clearer. I quickly create a dyn file and uploaded here. It will be the same story with the screen capture, which is left side lists to form a new list like the right one.
example.dyn (32.6 KB)
