hi..,
I'm new to the exceltoci environment. My problem is, i have 2 components and 2nd component is dependent on the first one. that is: setid and item id are provided in first compoent and this inturn will reflect in second comp too. I can enter data for first ci and the tables gets these data.. but i don't know how to join the second ci in this exceltoci. Wanna know whether there is any possiblity to put 2 ci together in single excel.
Do plz provide me a solution.
Thanks in advance

ExcelToCI only works with one component at a time. You'll need to do your load in two steps with two spreadsheets.

But this 2 components are interdependent. only in the first comp we will provide the key fields. this inturn send the value to next page.. so if i put as another comp then it will show error msg like the row already exists. the problem is while automating the ITEMS comp in the portal. there are more than 1 comp in it. i want to refer the item_id field of first comp in the second one.. how shall i do it? plz i'm very much in need of this.

If I understand what you're trying to do correctly I still think you need two spreadsheets. The first one will populate the first component using "Add" mode. The second spreadsheet will populate the second component using "Update/Display" mode so you don't get the row already exists error. You'll need both spreadsheets to provide key values, even if it doesn't look that way online.

I'm assuming you're providing the ITEM_ID values and not letting the system generate them. That way you'll have the same key values in both spreadsheets.

Keep in mind, ExcelToCI was really intended for semi-technical people to be able to enter a bunch of data quickly without requiring special programming. As a result it's fairly limited and doesn't work with every component. You'll need to be creative and flexible and work within the tool's capabilities.

Thank u Brent.