Unstructured Data transformation: Reading in Transactional data
-
Hi there,
I have some transactional data I would like to read into Omniscope if possible.. If not, any ideas of other programs/software I could potentially use would be appreciated.
I have attached an excel file with a few quick examples of the data (and its breakdown). Ideally I would like to read in each separate transaction into an amount of records that corresponds to how many products there are in that transaction. So for each product I would have date/time/payment method/units/value/multibuy information etc...
Would this be possible on Omniscope?
Many thanks.Attachments
example of data breakdown.xlsx 12K -
1 Comment
-
Omniscope can deal with unstructured data, as long as there is consistency e.g. 6 stands for new record, number of characters in Product code is the same, or there is logic that can be applied to divide concatenated text into multiple fields.
Please have a look at the suggested workflow - you will have to do this only once...
If you can find a better piece of software to do this, please let us know ;-)
From this:
To this:
AttachmentsdataSample.JPG 60K unstructViz.JPG 109K UnstructuredData.iok 38K UnstructuredData.xlsx 11K
Welcome!
It looks like you're new here. If you want to get involved, click one of these buttons!
Categories
- All Discussions2,595
- General680
- Blog126
- Support1,177
- Ideas527
- Demos11
- Power tips72
- 3.0 preview2
To send files privately to Visokio email support@visokio.com the files together with a brief description of the problem.