Hello!
I’m having some issues with labeling data in Data Manager and getting the desired values. On the form that I am labeling and extracting information from, there’s a table where rows are continued on separate columns (please see the image below for an example).
Using a Column Field to label the data, I’d like the extracted rows to be the following-
Row 1: Value 1
Row 2: Value 2
Row 3: Value 3
Row 4: Value 4
…
But instead the data is being read across as if in one row-
Row 1: Value 1 Value 4 Value 7
Row 2: Value 2 Value 5 Value 8
Row 3: Value 3 Value 6 Value 9
Ideally I would have one Column Field and each cell would be read as a different row/value, but I’ve been trying to think about other ways if that isn’t possible. Maybe I can have 3 Column Fields and for each of the different group of cells, but I worry if the form might change to include more or fewer columns. Another thought I had was to allow it to be read across and then split the value, though I don’t have a consistent delimiter between values to do so.
Does anyone have a suggestion or had to handle this issue before? Thank you!
Hi @kcroland ,
You can filter data table then write by column
Regards,
Hi thank you for the suggestion! Could you clarify what you mean?
Hi @kcroland ,
My input
My solution
Can you share your input?
regards,
Hi @kcroland ,
Considering the Retrieval Point of view, your data to extract seems to be a list of values rather than a Table/Columns Structure.
You could try by opting the Multi Value and Label the Documents with that Field to have Multi Value Setting and check the if the result is what you require.
This is suggested because, there was a mention of the Columns being increased or Decreased, so we cannot maintain a proper Taxonomy for it.
Hi @supermanPunch,
What you’re saying makes a lot of sense, it is more of a list of values (or a table with only one column). I should have mention that I am using AI Center version 21.10.3 with air-gapped deployment and I’m not seeing the Multi Value checkbox for Regular or Column fields.
Hi @Nguyen_Van_Luong1,
My issue is in Data Manager rather than Excel, the screenshot is from Excel only because the data on the form is sensitive so I tried to replicate it. However I do appreciate you taking the time to create a sample and share screenshots of your suggested solution!
@kcroland ,
Yes. It was introduced later with 22.10 version I believe.
Maybe an Alternate would be to mark/Label all the values as One Column data (First Line being first row, second line being second row), then in the Post Processing Part, after the extraction that is, we should be able to separate the data in one row value containing multiple values into multiple rows, but even for this there should be a limiter to identify the separation of data values.
Hi @kcroland ,
I understand your problem. However, it must be as specific as possible to be able to solve it. I understand here you have 1 data and need to split it like the picture. it’s the same thing.
Anil_G
A_Learner
ashokkarale
lrtetala
Ritaman_Baral