I am looking at valve turning data from a hand held device which is stored in an access database.
The database has torque charts stored as an attribute in one of the tables ,It is an encoded (UTF-16LE)
My intention is to split this into separate columns and make an histogram chart from it.
Any direction on how to get at it will be very much appreciated.
Best answer by debbiatsafe
Hi @adi
Based on the structure of your data, I would suggest using a combination of AttributeSplitter (split on new line character), ListExploder to create features for each line in the torque chart, and then another AttributeSplitter (split on the delimiter character for each attribute). You should then be able to create attributes using an AttributeManager or AttributeCreator. You may also want to use a Tester to only get lines that are not header lines (ie. data only) after the second AttributeSplitter.
+20Hi @adi
Based on the structure of your data, I would suggest using a combination of AttributeSplitter (split on new line character), ListExploder to create features for each line in the torque chart, and then another AttributeSplitter (split on the delimiter character for each attribute). You should then be able to create attributes using an AttributeManager or AttributeCreator. You may also want to use a Tester to only get lines that are not header lines (ie. data only) after the second AttributeSplitter.
Hi @adi
Based on the structure of your data, I would suggest using a combination of AttributeSplitter (split on new line character), ListExploder to create features for each line in the torque chart, and then another AttributeSplitter (split on the delimiter character for each attribute). You should then be able to create attributes using an AttributeManager or AttributeCreator. You may also want to use a Tester to only get lines that are not header lines (ie. data only) after the second AttributeSplitter.
This is exactly what I was looking for , Richard Mosley from FME support has also suggested the same and I was able to accomplish what I was after.
Thanks
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
