http://forums.visokio.com/discussions/tagged/merge-and-append/feed.rss Mon, 30 Oct 17 12:12:26 -0400 Tagged with merge-and-append - Visokio Forums en-CA http://forums.visokio.com/discussion/3225/3.0-version-testing-some-observations Mon, 03 Apr 2017 06:39:38 -0400 acohen 3225@/discussions
1) How does one configure an end user dashboard? At the moment the navigation is via datamanager and clicking on the Visokio eyes to view the reports.
2) Will it be possible to link data in two different datasets into one report on a joining field? For example if the field "Name" is common but everything else is not.
3) The Field Metadata seemed to give me the wrong number of records for the Demo:Hurricane data. The dataset has 2038 records however Field Metadata shows 909 records
4) The aggregation block does not seem to work for unique value list when applied to a dates field

Looking forward to future developments,]]> http://forums.visokio.com/discussion/3241/datamanager-merge-join-operation-block-limits Thu, 11 May 2017 06:05:06 -0400 luukvanm 3241@/discussions
I was wondering if there is a limit (100 000 000) on the join block (see image). Or is this a coincidence?

Thanks in advance

]]> http://forums.visokio.com/discussion/2590/idea-sql-database-output-merge-new-changed-recordss Wed, 11 Jun 2014 06:59:51 -0400 SimonWiggins 2590@/discussions
I'm looking to update a SQL table daily with new data. Obviously an Append would do this job if the data to be added was always only new data.

The problem comes when some values from previous days have been corrected or updated and these also need pushing to the same database.

I have a solution that compares the last few days data (from the database) with the same number of days from the source and if it's new it Appends, if it's corrected it Updates. The solution is adequate if a bit slow for large data sets as it appears to publish line by line and requires the last few days from the database to be pulled back into the Omniscope process.

My idea/suggestion would be to include another option in the Database output block that uses the Merge command.
If anyone else has solutions for this that work better please let me know. Not sure if this is possible or even has enough people wanting it?

Thanks,]]> http://forums.visokio.com/discussion/2500/mergejoin-multi-table-vlookup-problem Tue, 25 Mar 2014 04:05:10 -0400 Nemesis 2500@/discussions ABC
BCD
DEF
NDH
FRD
TRY
ENT

Table 2 Value
ABC 1
DEF 3
NDH 5

Table 3 Value
ABC 2
BCD 3
FRD 5
TRY 6

Table 4 Value
NDH 2
ENT 5
ABC 3

I want to pull up values for list in table 1 from table 2,3,4

I tried merging (1&2, 1&3, 1&4) uniques then appending all/ Appending all then merging with Table 1 but it gives duplicates. when i remove duplicates it using table 1 identifiers it removes few values like in ABC when all are appended it looks like

ABC 1
ABC 2
ABC 3

But i want something like one the same line
Value 1 Value 2 Value 3
ABC 1 2 3

Am unable to achieve this. Please help.]]> http://forums.visokio.com/discussion/2141/mergejoin-row-counts Tue, 14 May 2013 12:21:31 -0400 nicci113 2141@/discussions
Please suggest. I don't have anybody in work to guide me through.
Thanks,]]> http://forums.visokio.com/discussion/1265/merging-different-frequency-data Mon, 30 Jan 2012 07:08:23 -0500 anna 1265@/discussions http://forums.visokio.com/discussion/122/multiple-data-sets-in-same-report Wed, 03 Jun 2009 10:29:18 -0400 Allan 122@/discussions http://forums.visokio.com/discussion/456/datamanager-case-sensitive-matchings Wed, 20 Oct 2010 11:05:51 -0400 SteveP 456@/discussions Thanks - Steve]]>