LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: KWalden

1. How do I upload a .csv file to LAE/Bre?
2. Then I want to merge the uploaded file with files from db query results.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: timonk

Utilize the "CSV File" node to load basic .csv files into a graph.
Use the DB Query or DB Execute nodes to pull information from your chosen databases. Please note you must provide any drivers needed for your specific database.

Once your data has been loaded, it depends on what you mean by "merge". If you want to integrate the data, you can use the variou JOIN nodes, or an XREF. If you literally want to just stack the data together, you can use the CAT node.

I strongly suggest you look through the nodes available to you through the core libraries, and see the documentation for them. (Look under the HELP menu item in BRE).

Regards,
Timon
Lavastorm Analytics Support.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: KWalden

I am joing the CSV file and BD Query with xref join. I am getting an error from CSV file unknown field source and invalid type long.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rboccuzzi

Without seeing your code and some sample data it is hard to help. Is the data sensitive, or can you attach a zip with your graph and some data?

Under Help, there is a choice "Report Problem With a Node feature", this can create a directory with your graphs and some sample of your data.

You can highlight the node with the issue and then choose this menu item, and it will help create a directory that you can zip and attach for more help.

Cheers
Rich