Reading unstructured data from Excel

CloverDX Platform
1

Hi,

I am trying to read 3 fields(Clover,2,"Central) Client, Build Version and Region from a Excel sheet into Clover. I need to read these dynamically as my input file changes every time.
Screen Shot 2014-04-24 at 11.27.42 AM.png
Is there an easy way to do this? I am thinking using parameters could be one option but not sure how to make it dynamic.
I have attached a screenshot of how my input looks.
I would appreciate your help.

Thanks a ton.

2

Hi,

I am trying to read data(Client, Build Version and Region) values from an Excel file dynamically.

I have tried to read it using XLS reader and it worked but I am pretty sure there is a better way to do it. Maybe using parameters?

Do you think you could help me figure it out? I have attached a screenshot for your reference.

Thanks for your time.

-Regards

Shweta

3

Hi Shweta,

What do you mean by “dynamically”, please? Does the position of these fields change? How? Horizontally, vertically, among various sheets or among various files? Could you please describe your task in more details?

Thanks,

4

Hello imriskal,

By dynamically, I mean every time I change the input file. The position of these fields does not change. Its pretty much constant.
Sorry for confusing you.

Thanks.

5

Ok, great. If the position is constant, you can read the whole file, pick just the fields you need and store them in dictionary. At the end, join dictionary values into one record. Please see the example graph. The conditions in if clauses in the first Reformat are just for the purpose of the example, maybe you can find some more suitable ones.unstructured.zipRegards,