Undefined Collection Reference

[KenroyNembhard]

I have a massive excel file that I have sent to an undefined collection. With a collection that has fields that are set up in advance, you can reference the column/field by using [collection.field1] With an undefined collection, there are no predefined fields.  How can I reference a column/field when the collection is undefined  

[Hemachanderrao]

Hi,  You can put a breakpoint after reading the excel data into a collection. Open the undefined collection Data Item->Current Values. You can see the Column names in there. You could then use the same format as a defined collection to reference the fields. ( ex: [Collection dataitem.]   Thanks!

[Hemachanderrao]

Pls check the attachment. Hope this is of help.

[Hemachanderrao]

Pls check the attachment. Hope this is of help.

[KenroyNembhard]

Ok, I'll give this a try.    This should this work without the break, right?

[KenroyNembhard]

Looks like it works! Thanks a bunch!

[AndreyKudinov]

If headers are consisent, you just reference it by header names. If you read without headers, it's Column1, Column2 etc..