Fill a column (from datatable) with a value based on another column in excel

Help Studio
, , ,
1

Hello, i have a problem in my build

So I have an excel like this
image

for the container column, I already used a data scraping from a website, and want to insert the data to the excel, with condition:

  1. For a same product, it will only use 1 container
  2. Different product will use different container
    So in the end, the output that I want is like this:
    image
    the list of usable container are listed in datatable from datascraping i mentioned above (in the first column)
2

Hi @Fauzan_Marantama

How the container values are taken can u show the scrapped container values ?

3

Here is what its look like
image
the container code will be picked from the first column, other column are not important
p.s
I already remove the first 2 row using remove data row

4

So my doubt was how u can map the container to the product

If u can clear that part too it would be good :blush:

5

The condition to map the container to the product are:

  1. For a same product, it will only use 1 container
  2. Different product will use different container
    So in the end, the output that I want is like this:
    image

for the product and container, it doesnt have any requirement, its free how you pair them

6

Check if this video helps @Fauzan_Marantama : Understanding Lookup Data Table With Use Case - YouTube

7

thank you for the answers
the video is a how to lookup from datatable, where in my case i can’t do lookup because in the excel file i dont have anything to be the lookup, i just need to put a random container ID that are existed in the datatable to the excel with condiiton that 1 container ID can onlye store 1 kind of product, but in an unlimited qty

8

So you just want to simply add the column beside the product ? @Fauzan_Marantama

9

yes, the data are from first column in the datatable, and when the product name changes it will add the next row of the data in the datatable