This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Thanks a lot but workflow is not giving me the right output.
I have few excel files with the sample input i attached here ..
There are many empty values like this. I need to Extract all the information from these excels .so my headings for the output becomes: Name(marked in yellow) ,Date(cell under yellow),Plan, Birth data, marriage date, amount , cash, currentValue1,lapse date, no. of ideas,Idea Price.
All this information header are not in same row so need to make them structured .Also in this excel we have empty values for lapse date , No.of ideas but in future i may have some values there so need to make it flexible .if in future we get some value here .my workflow could extract the info.
It's a little tricky to see which records you want to keep with so many nulls in your sample dataset, but let's give this a try.
I marked any row that contains "Current" because that seemed to be one way to isolate a header row. I created groups of records based on everything from the header row down to the next identified header row. I wrote a new batch bacro to process each group of these records and dynamically rename the fields. So basically, it's a macro in a macro to deal with the fact that your header rows do not match up into columns.
I left all the nulls and blanks so you can see how the data is being pieced together. You might want to drop records by using a filter tool right before the browse tool.
Play around with this and let us know if we're getting warmer!
populating the data to respective column ddiesel2.yxzp